GO
CREATE SCHEMA S AUTHORIZATION CHENJUN
CREATE TABLE S(SNO VARCHAR(255),SNAME VARCHAR(255),STATUS VARCHAR(255),CITY VARCHAR(255));
GO
GO
CREATE SCHEMA P AUTHORIZATION CHENJUN
CREATE TABLE P(PNO VARCHAR(255),PNAME VARCHAR(255),COLOR VARCHAR(255),WEIGHT SMALLINT);
GO
GO
CREATE SCHEMA J AUTHORIZATION CHENJUN
CREATE TABLE J(JNO VARCHAR(255),JNAME VARCHAR(255),CITY VARCHAR(255));
GO 
GO
CREATE SCHEMA SPJ AUTHORIZATION CHENJUN
CREATE TABLE SPJ(SNO VARCHAR(255),PNO VARCHAR(255),JNO VARCHAR(255),QTY SMALLINT);
GO